[Database] Database Access Settings

Sets options for accessing the database.

Parameter Default Description

Parameter	Default	Description
`dbName`	N/A	Specifies the name of the database to back up. If you do not supply a database name, the `vbr` utility selects the current database to back up. OpenText recommends that you provide a database name.
`dbUser`	Current user name	Identifies the Vertica user used for database operations performed by vbr. In the case of the replicate task, this user is the source database user. You must be logged on as the database administrator to back up the database. The password, if you choose to save it, is stored in the Password Configuration File.
`dbPromptForPassword`	True	Controls whether the utility prompts for a password. If you set this parameter to `False` (indicating no prompt at run time), then you must also enter the database administrator password in the `dbPassword` parameter. If you do not supply a password in the configuration file, the utility prompts for one at run time.

dbName

N/A

Specifies the name of the database to back up. If you do not supply a database name, the vbr utility selects the current database to back up.

OpenText recommends that you provide a database name.

dbUser

Current user name

Identifies the Vertica user used for database operations performed by vbr. In the case of the replicate task, this user is the source database user. You must be logged on as the database administrator to back up the database. The password, if you choose to save it, is stored in the Password Configuration File.

dbPromptForPassword

True

Controls whether the utility prompts for a password. If you set this parameter to False (indicating no prompt at run time), then you must also enter the database administrator password in the dbPassword parameter. If you do not supply a password in the configuration file, the utility prompts for one at run time.

Vertica uses destination database parameters only to replicate objects to alternate clusters. By default, these parameters do not exist in your vbr configuation files. You must manually edit your database configuration file to add them.

Parameter	Default	Description
`dest_dbName`	N/A	Specifies the name of the destination database.
`dest_dbUser`	N/A	Identifies the Vertica user name in the destination database to be used for loading the replicated data. This Vertica user must have default super user privileges.
`dest_dbPromptForPassword`	N/A	Controls whether the utility prompts for a password for the destination database. If you set this parameter to `False` (indicating no prompt at run time), then you must also enter the destination database administrator password in the `dest_dbPassword` parameter. If you do not supply a password in the configuration file, the utility prompts for one at run time.